package com.gla.dao;

import com.gla.domain.Commodity;
import com.gla.domain.Shop;
import com.gla.domain.Video;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface VideoMapper {

    @Select("SELECT * FROM VIDEO")
    List<Video> getAllShop();

    @Select("SELECT * FROM COMMODITY WHERE P_O_U = 0")
    List<Commodity> getPet();

    @Select("SELECT * FROM COMMODITY WHERE P_O_U = 1")
    List<Commodity> getPetGoods();

    @Select("SELECT * FROM COMMODITY WHERE id = #{id}")
    Commodity findCommodityName(Integer id);
}
